package com.meet.service;

import com.meet.entity.BoardRoom;
import com.meet.entity.PageBean;
import com.meet.vo.BoardRoomTimeVo;

import java.sql.SQLException;
import java.util.List;

/**
 * @author RicardoZeng
 * @date 2022/8/11 21:14
 */
public interface BoardRoomService {

    /**
     * 查找所有会议室
     * @param currentPage
     * @param rows
     * @return
     * @throws SQLException
     */
    public List<BoardRoom> getAllRooms(int currentPage, int rows) throws SQLException;

    /**
     * 添加会议室
     * @param boardRoom
     * @return
     * @throws SQLException
     */
    public int addBoardRoom(BoardRoom boardRoom) throws SQLException;

    /**+
     * 删除会议室
     * @param Id
     * @return
     * @throws SQLException
     */
    public int deleteBoardRoom(Integer Id) throws SQLException;

    /**
     * 更新会议室信息
     * @param boardRoom
     * @return
     * @throws SQLException
     */
    public int updateBoardRoom(BoardRoom boardRoom) throws SQLException;

    /**
     * 表中记录数
     * @return
     * @throws SQLException
     */
    public int count() throws SQLException;

    /**
     * 分页
     * @param _currentPage
     * @param _rows
     * @return
     * @throws SQLException
     */
    public PageBean<BoardRoom> getAllRoomsByPage(String _currentPage, String _rows) throws SQLException;

    /**
     * 根据Id查询会议室
     * @param Id
     * @return
     * @throws SQLException
     */
    public BoardRoom getRoom(Integer Id) throws SQLException;

    /**
     * ldy写的
     * @param id
     * @return
     * @throws SQLException
     */
    public List<BoardRoomTimeVo> getBoardRoomTime(Integer id) throws SQLException;
}
